create procedure [dbo].[BAEOrderCategoryParentLookupUpdate] @OrderCategoryID as
int,
    @OrderCategoryParentID AS int
AS
    UPDATE OrderCategoryParentLookup
    SET
    OrderCategoryID = @OrderCategoryID,    
    OrderCategoryParentID = @OrderCategoryParentID        
            
    WHERE OrderCategoryID = @OrderCategoryID AND
    OrderCategoryParentID = @OrderCategoryParentID;

GO